﻿CREATE TABLE [dbo].[DefinedRelationshipChangers] (
    [RelationshipPermissionID] INT           IDENTITY (1, 1) NOT NULL,
    [RelationshipToChange]     NVARCHAR (12) NOT NULL,
    [RelationshipChanger]      NVARCHAR (12) NOT NULL,
    CONSTRAINT [PK_DefinedRelationshipChangers] PRIMARY KEY CLUSTERED ([RelationshipPermissionID] ASC),
    CONSTRAINT [FK_DefinedRelationshipChangers_DefinedEntityRelationships] FOREIGN KEY ([RelationshipToChange]) REFERENCES [dbo].[DefinedEntityRelationships] ([ShortRelationshipName]),
    CONSTRAINT [FK_DefinedRelationshipChangers_DefinedEntityRelationships1] FOREIGN KEY ([RelationshipChanger]) REFERENCES [dbo].[DefinedEntityRelationships] ([ShortRelationshipName])
);



